Safety issues have always been in the spotlight, in the United States as strict gun regulations do not exist. And with the non-stop UW Alert messages reporting crimes, such as robberies and gun fires, safety has become one of the UW students’ major concerns nowadays. Therefore, as a team, we decided to tie this project to our daily lives and analyze the pattern of crimes around our community.
We will be using 3 data sets (SPD Crime Data, King County Sheriff’s Office - Incident Dataset, 911 Seattle Call Data). These datasets contain data such as offense start time, latitude & longitude, offense type, call-in resolution, etc., that help us answer these following questions:
| mcpp | offense | occurances | report_delay |
|---|---|---|---|
| QUEEN ANNE | Identity Theft | 2 | 56630.14 hours |
| SOUTH BEACON HILL | Wire Fraud | 1 | 35872.95 hours |
| MID BEACON HILL | Rape | 1 | 31411.55 hours |
| NORTH BEACON HILL | Identity Theft | 1 | 11386.80 hours |
| UNIVERSITY | Wire Fraud | 1 | 8781.31 hours |
| ROXHILL/WESTWOOD/ARBOR HEIGHTS | Motor Vehicle Theft | 1 | 8768.24 hours |
| SOUTH BEACON HILL | Identity Theft | 1 | 6712.87 hours |
| BRIGHTON/DUNLAP | Identity Theft | 1 | 5243.04 hours |
| NORTH ADMIRAL | Identity Theft | 2 | 4451.62 hours |
| BALLARD SOUTH | Identity Theft | 2 | 3779.58 hours |
| MOUNT BAKER | All Other Larceny | 1 | 3693.72 hours |
| PIONEER SQUARE | All Other Larceny | 2 | 3059.41 hours |
| MID BEACON HILL | Identity Theft | 1 | 2893.53 hours |
| SLU/CASCADE | Embezzlement | 1 | 2893.25 hours |
| MILLER PARK | Identity Theft | 1 | 2150.25 hours |
| MADISON PARK | Identity Theft | 1 | 1737.71 hours |
| SANDPOINT | Theft From Building | 1 | 1546.44 hours |
| HILLMAN CITY | All Other Larceny | 1 | 1514.64 hours |
| BRIGHTON/DUNLAP | Theft of Motor Vehicle Parts or Accessories | 4 | 1509.39 hours |
| ROXHILL/WESTWOOD/ARBOR HEIGHTS | Destruction/Damage/Vandalism of Property | 1 | 1501.34 hours |
| ROOSEVELT/RAVENNA | Fondling | 1 | 1491.80 hours |
| SANDPOINT | Human Trafficking, Commercial Sex Acts | 1 | 1441.09 hours |
| MID BEACON HILL | All Other Larceny | 2 | 1231.18 hours |
| FIRST HILL | Counterfeiting/Forgery | 2 | 1199.28 hours |
| NORTH ADMIRAL | All Other Larceny | 1 | 1144.09 hours |
| ROOSEVELT/RAVENNA | False Pretenses/Swindle/Confidence Game | 1 | 1135.64 hours |
| MADISON PARK | Credit Card/Automated Teller Machine Fraud | 1 | 1033.32 hours |
| BALLARD SOUTH | Destruction/Damage/Vandalism of Property | 5 | 1012.99 hours |
| JUDKINS PARK/NORTH BEACON HILL | Impersonation | 1 | 951.07 hours |
| MORGAN | Theft of Motor Vehicle Parts or Accessories | 1 | 849.52 hours |
| UNIVERSITY | Credit Card/Automated Teller Machine Fraud | 2 | 792.91 hours |
| CENTRAL AREA/SQUIRE PARK | Extortion/Blackmail | 1 | 760.10 hours |
| JUDKINS PARK/NORTH BEACON HILL | All Other Larceny | 2 | 740.51 hours |
| PIONEER SQUARE | Theft From Building | 3 | 718.60 hours |
| ROOSEVELT/RAVENNA | Credit Card/Automated Teller Machine Fraud | 1 | 690.71 hours |
| BALLARD NORTH | Credit Card/Automated Teller Machine Fraud | 1 | 665.31 hours |
| SODO | Destruction/Damage/Vandalism of Property | 3 | 606.15 hours |
| ROXHILL/WESTWOOD/ARBOR HEIGHTS | All Other Larceny | 2 | 602.28 hours |
| CHINATOWN/INTERNATIONAL DISTRICT | Fondling | 1 | 594.69 hours |
| QUEEN ANNE | Impersonation | 1 | 567.44 hours |
| GREENWOOD | Theft From Building | 1 | 557.79 hours |
| CAPITOL HILL | Impersonation | 2 | 533.72 hours |
| FREMONT | Identity Theft | 1 | 515.21 hours |
| DOWNTOWN COMMERCIAL | Theft of Motor Vehicle Parts or Accessories | 1 | 493.66 hours |
| SLU/CASCADE | False Pretenses/Swindle/Confidence Game | 1 | 492.30 hours |
| UNIVERSITY | Theft From Motor Vehicle | 20 | 486.13 hours |
| LAKEWOOD/SEWARD PARK | Identity Theft | 1 | 456.80 hours |
| GEORGETOWN | Credit Card/Automated Teller Machine Fraud | 1 | 432.62 hours |
| BITTERLAKE | Identity Theft | 1 | 429.56 hours |
| CENTRAL AREA/SQUIRE PARK | Counterfeiting/Forgery | 1 | 404.34 hours |
| CENTRAL AREA/SQUIRE PARK | Wire Fraud | 1 | 404.34 hours |
| CHINATOWN/INTERNATIONAL DISTRICT | All Other Larceny | 2 | 396.41 hours |
| PIONEER SQUARE | Destruction/Damage/Vandalism of Property | 4 | 388.36 hours |
| PIONEER SQUARE | Theft From Motor Vehicle | 2 | 381.71 hours |
| ROOSEVELT/RAVENNA | Theft From Building | 1 | 370.30 hours |
| SODO | Wire Fraud | 1 | 357.22 hours |
| MAGNOLIA | Shoplifting | 2 | 320.53 hours |
| NORTHGATE | Theft From Motor Vehicle | 7 | 320.31 hours |
| WALLINGFORD | All Other Larceny | 2 | 315.75 hours |
| BRIGHTON/DUNLAP | All Other Larceny | 3 | 315.12 hours |
| DOWNTOWN COMMERCIAL | Credit Card/Automated Teller Machine Fraud | 1 | 296.87 hours |
| MILLER PARK | Theft From Motor Vehicle | 2 | 295.08 hours |
| DOWNTOWN COMMERCIAL | All Other Larceny | 13 | 294.18 hours |
| RAINIER VIEW | All Other Larceny | 2 | 269.12 hours |
| ALASKA JUNCTION | Theft From Motor Vehicle | 5 | 263.36 hours |
| ALASKA JUNCTION | Motor Vehicle Theft | 2 | 262.98 hours |
| MADRONA/LESCHI | Counterfeiting/Forgery | 1 | 250.27 hours |
| SANDPOINT | Identity Theft | 1 | 246.91 hours |
| MONTLAKE/PORTAGE BAY | Motor Vehicle Theft | 1 | 240.71 hours |
| CENTRAL AREA/SQUIRE PARK | Destruction/Damage/Vandalism of Property | 4 | 237.84 hours |
| ROOSEVELT/RAVENNA | Shoplifting | 10 | 228.91 hours |
| QUEEN ANNE | Theft From Building | 5 | 210.39 hours |
| BITTERLAKE | All Other Larceny | 2 | 208.06 hours |
| HIGH POINT | Shoplifting | 2 | 201.39 hours |
| UNIVERSITY | All Other Larceny | 2 | 195.73 hours |
| ALASKA JUNCTION | Credit Card/Automated Teller Machine Fraud | 1 | 192.37 hours |
| SOUTH BEACON HILL | Theft From Motor Vehicle | 1 | 191.24 hours |
| JUDKINS PARK/NORTH BEACON HILL | Theft From Motor Vehicle | 4 | 189.91 hours |
| SLU/CASCADE | Theft From Building | 3 | 184.40 hours |
| EASTLAKE - WEST | All Other Larceny | 3 | 183.82 hours |
| ALASKA JUNCTION | Counterfeiting/Forgery | 1 | 183.01 hours |
| SANDPOINT | Destruction/Damage/Vandalism of Property | 2 | 181.72 hours |
| WALLINGFORD | Counterfeiting/Forgery | 1 | 177.51 hours |
| GREENWOOD | Identity Theft | 1 | 174.37 hours |
| MAGNOLIA | Motor Vehicle Theft | 1 | 173.51 hours |
| FAUNTLEROY SW | Theft From Building | 1 | 171.82 hours |
| MORGAN | All Other Larceny | 1 | 168.10 hours |
| BELLTOWN | All Other Larceny | 3 | 163.33 hours |
| HIGH POINT | Identity Theft | 1 | 157.73 hours |
| MONTLAKE/PORTAGE BAY | Destruction/Damage/Vandalism of Property | 2 | 157.56 hours |
| JUDKINS PARK/NORTH BEACON HILL | Driving Under the Influence | 2 | 145.86 hours |
| SOUTH DELRIDGE | All Other Larceny | 4 | 138.27 hours |
| BITTERLAKE | Theft From Motor Vehicle | 3 | 132.55 hours |
| PIONEER SQUARE | Sodomy | 1 | 125.70 hours |
| NORTH ADMIRAL | Theft From Motor Vehicle | 4 | 124.76 hours |
| COLUMBIA CITY | Kidnapping/Abduction | 1 | 121.73 hours |
| COLUMBIA CITY | Theft From Building | 1 | 121.73 hours |
| ROOSEVELT/RAVENNA | Wire Fraud | 1 | 120.87 hours |
| SOUTH PARK | Destruction/Damage/Vandalism of Property | 1 | 118.04 hours |
| RAINIER VIEW | Identity Theft | 2 | 111.19 hours |
| PHINNEY RIDGE | Theft From Motor Vehicle | 2 | 108.51 hours |
| GREENWOOD | Destruction/Damage/Vandalism of Property | 3 | 108.30 hours |
| HIGH POINT | Theft From Motor Vehicle | 1 | 107.88 hours |
| SLU/CASCADE | Identity Theft | 3 | 107.23 hours |
| MAGNOLIA | False Pretenses/Swindle/Confidence Game | 1 | 106.04 hours |
| CHINATOWN/INTERNATIONAL DISTRICT | Identity Theft | 2 | 103.23 hours |
| NORTH DELRIDGE | Theft From Motor Vehicle | 2 | 101.33 hours |
| WALLINGFORD | Hacking/Computer Invasion | 1 | 100.22 hours |
| BELLTOWN | Credit Card/Automated Teller Machine Fraud | 2 | 98.77 hours |
| MORGAN | Identity Theft | 1 | 96.85 hours |
| CAPITOL HILL | Theft From Building | 7 | 95.26 hours |
| SLU/CASCADE | Bad Checks | 1 | 93.87 hours |
| CAPITOL HILL | Credit Card/Automated Teller Machine Fraud | 1 | 91.54 hours |
| WALLINGFORD | Robbery | 1 | 90.27 hours |
| MADRONA/LESCHI | All Other Larceny | 1 | 88.04 hours |
| BELLTOWN | Theft From Building | 3 | 87.41 hours |
| SLU/CASCADE | All Other Larceny | 4 | 87.12 hours |
| FIRST HILL | Theft From Motor Vehicle | 10 | 86.29 hours |
| BALLARD SOUTH | Theft From Motor Vehicle | 20 | 85.16 hours |
| CLAREMONT/RAINIER VISTA | Theft From Motor Vehicle | 1 | 83.58 hours |
| SANDPOINT | Credit Card/Automated Teller Machine Fraud | 2 | 81.74 hours |
| GREENWOOD | All Other Larceny | 2 | 79.29 hours |
| CHINATOWN/INTERNATIONAL DISTRICT | Theft of Motor Vehicle Parts or Accessories | 1 | 78.86 hours |
| BALLARD NORTH | All Other Larceny | 3 | 78.37 hours |
| HIGHLAND PARK | Credit Card/Automated Teller Machine Fraud | 1 | 78.11 hours |
| ROOSEVELT/RAVENNA | All Other Larceny | 2 | 77.87 hours |
| FREMONT | Destruction/Damage/Vandalism of Property | 4 | 77.68 hours |
| DOWNTOWN COMMERCIAL | Theft From Building | 5 | 77.04 hours |
| ALASKA JUNCTION | All Other Larceny | 4 | 76.76 hours |
| UNIVERSITY | Theft From Building | 2 | 71.56 hours |
| ROOSEVELT/RAVENNA | Identity Theft | 1 | 71.40 hours |
| PIGEON POINT | All Other Larceny | 3 | 71.27 hours |
| SOUTH PARK | Theft of Motor Vehicle Parts or Accessories | 1 | 71.16 hours |
| ALASKA JUNCTION | False Pretenses/Swindle/Confidence Game | 1 | 70.38 hours |
| GEORGETOWN | Motor Vehicle Theft | 2 | 68.17 hours |
| EASTLAKE - WEST | Theft From Motor Vehicle | 3 | 65.86 hours |
| CENTRAL AREA/SQUIRE PARK | Theft From Motor Vehicle | 9 | 64.30 hours |
| CENTRAL AREA/SQUIRE PARK | Pornography/Obscene Material | 1 | 64.10 hours |
| BALLARD SOUTH | Motor Vehicle Theft | 1 | 61.82 hours |
| NORTHGATE | Theft of Motor Vehicle Parts or Accessories | 2 | 60.61 hours |
| PIONEER SQUARE | Pocket-picking | 1 | 60.41 hours |
| MADISON PARK | All Other Larceny | 1 | 59.54 hours |
| FREMONT | All Other Larceny | 1 | 59.12 hours |
| WALLINGFORD | Theft From Motor Vehicle | 4 | 57.51 hours |
| HIGH POINT | All Other Larceny | 2 | 57.32 hours |
| BALLARD SOUTH | Theft From Building | 1 | 54.87 hours |
| GEORGETOWN | Destruction/Damage/Vandalism of Property | 3 | 54.60 hours |
| ROOSEVELT/RAVENNA | Theft of Motor Vehicle Parts or Accessories | 3 | 53.60 hours |
| ALKI | Theft of Motor Vehicle Parts or Accessories | 1 | 53.09 hours |
| CHINATOWN/INTERNATIONAL DISTRICT | Theft From Motor Vehicle | 7 | 52.86 hours |
| QUEEN ANNE | Credit Card/Automated Teller Machine Fraud | 1 | 50.21 hours |
| SODO | Driving Under the Influence | 1 | 48.00 hours |
| BALLARD NORTH | Theft of Motor Vehicle Parts or Accessories | 1 | 47.87 hours |
| QUEEN ANNE | Theft of Motor Vehicle Parts or Accessories | 3 | 46.32 hours |
| QUEEN ANNE | Theft From Motor Vehicle | 28 | 45.74 hours |
| NORTH DELRIDGE | Theft From Building | 1 | 45.69 hours |
| SLU/CASCADE | Credit Card/Automated Teller Machine Fraud | 2 | 45.66 hours |
| CHINATOWN/INTERNATIONAL DISTRICT | Destruction/Damage/Vandalism of Property | 6 | 44.78 hours |
| SANDPOINT | All Other Larceny | 1 | 44.54 hours |
| MAGNOLIA | Theft From Motor Vehicle | 9 | 43.77 hours |
| GREENWOOD | Credit Card/Automated Teller Machine Fraud | 1 | 41.37 hours |
| HILLMAN CITY | Theft From Motor Vehicle | 1 | 41.37 hours |
| FREMONT | Theft of Motor Vehicle Parts or Accessories | 1 | 41.24 hours |
| SLU/CASCADE | Arson | 1 | 40.26 hours |
| CENTRAL AREA/SQUIRE PARK | False Pretenses/Swindle/Confidence Game | 1 | 40.22 hours |
| NORTH DELRIDGE | Theft of Motor Vehicle Parts or Accessories | 1 | 39.55 hours |
| FREMONT | Theft From Motor Vehicle | 8 | 39.05 hours |
| CAPITOL HILL | All Other Larceny | 10 | 38.94 hours |
| MID BEACON HILL | Theft From Motor Vehicle | 1 | 38.17 hours |
| COLUMBIA CITY | Theft From Motor Vehicle | 1 | 38.13 hours |
| HIGHLAND PARK | Counterfeiting/Forgery | 1 | 37.68 hours |
| JUDKINS PARK/NORTH BEACON HILL | Hacking/Computer Invasion | 1 | 37.64 hours |
| CLAREMONT/RAINIER VISTA | All Other Larceny | 3 | 37.44 hours |
| QUEEN ANNE | Destruction/Damage/Vandalism of Property | 9 | 36.31 hours |
| MOUNT BAKER | Theft From Motor Vehicle | 4 | 35.94 hours |
| NORTH DELRIDGE | Destruction/Damage/Vandalism of Property | 3 | 35.94 hours |
| QUEEN ANNE | All Other Larceny | 6 | 35.42 hours |
| CAPITOL HILL | Theft of Motor Vehicle Parts or Accessories | 1 | 34.66 hours |
| BITTERLAKE | Theft of Motor Vehicle Parts or Accessories | 2 | 33.54 hours |
| CENTRAL AREA/SQUIRE PARK | All Other Larceny | 2 | 33.54 hours |
| NORTH DELRIDGE | Motor Vehicle Theft | 2 | 33.19 hours |
| UNKNOWN | Sodomy | 1 | 32.48 hours |
| ROOSEVELT/RAVENNA | Theft From Motor Vehicle | 12 | 31.91 hours |
| GEORGETOWN | All Other Larceny | 2 | 31.77 hours |
| ROOSEVELT/RAVENNA | Robbery | 2 | 31.76 hours |
| QUEEN ANNE | False Pretenses/Swindle/Confidence Game | 1 | 31.55 hours |
| NORTHGATE | Destruction/Damage/Vandalism of Property | 6 | 31.49 hours |
| NORTHGATE | Credit Card/Automated Teller Machine Fraud | 2 | 30.57 hours |
| BALLARD SOUTH | All Other Larceny | 4 | 30.32 hours |
| MAGNOLIA | All Other Larceny | 1 | 29.87 hours |
| SLU/CASCADE | Theft From Motor Vehicle | 11 | 29.54 hours |
| GREENWOOD | Theft From Motor Vehicle | 5 | 29.17 hours |
| SOUTH DELRIDGE | Destruction/Damage/Vandalism of Property | 1 | 29.09 hours |
| NORTH ADMIRAL | Driving Under the Influence | 1 | 28.59 hours |
| NORTHGATE | All Other Larceny | 2 | 28.42 hours |
| SANDPOINT | Hacking/Computer Invasion | 1 | 28.23 hours |
| SANDPOINT | Driving Under the Influence | 1 | 28.00 hours |
| ROXHILL/WESTWOOD/ARBOR HEIGHTS | Theft From Motor Vehicle | 4 | 27.84 hours |
| NORTH BEACON HILL | All Other Larceny | 3 | 27.83 hours |
| SODO | Theft From Building | 1 | 26.98 hours |
| NORTHGATE | Counterfeiting/Forgery | 1 | 26.66 hours |
| DOWNTOWN COMMERCIAL | Theft From Motor Vehicle | 18 | 25.23 hours |
| HILLMAN CITY | Embezzlement | 1 | 25.21 hours |
| SANDPOINT | Theft From Motor Vehicle | 8 | 24.78 hours |
| ROOSEVELT/RAVENNA | Destruction/Damage/Vandalism of Property | 7 | 24.55 hours |
| GEORGETOWN | Driving Under the Influence | 1 | 24.00 hours |
| BALLARD NORTH | Destruction/Damage/Vandalism of Property | 2 | 23.94 hours |
| MONTLAKE/PORTAGE BAY | Theft From Motor Vehicle | 3 | 23.34 hours |
| MOUNT BAKER | Extortion/Blackmail | 1 | 23.30 hours |
| FIRST HILL | Theft of Motor Vehicle Parts or Accessories | 2 | 23.22 hours |
| SODO | Theft From Motor Vehicle | 7 | 22.96 hours |
| FIRST HILL | Extortion/Blackmail | 1 | 22.87 hours |
| QUEEN ANNE | Motor Vehicle Theft | 5 | 22.85 hours |
| BITTERLAKE | Shoplifting | 1 | 22.64 hours |
| BRIGHTON/DUNLAP | Theft From Motor Vehicle | 1 | 22.37 hours |
| GENESEE | Theft From Motor Vehicle | 1 | 22.30 hours |
| SOUTH DELRIDGE | Theft From Motor Vehicle | 3 | 22.29 hours |
| UNIVERSITY | Impersonation | 1 | 22.17 hours |
| RAINIER VIEW | Theft From Motor Vehicle | 1 | 21.91 hours |
| PHINNEY RIDGE | All Other Larceny | 2 | 21.31 hours |
| FREMONT | Shoplifting | 4 | 21.16 hours |
| RAINIER VIEW | Motor Vehicle Theft | 1 | 20.80 hours |
| PHINNEY RIDGE | Theft From Building | 1 | 20.35 hours |
| MID BEACON HILL | Motor Vehicle Theft | 3 | 20.23 hours |
| CAPITOL HILL | Theft From Motor Vehicle | 8 | 19.92 hours |
| EASTLAKE - WEST | Motor Vehicle Theft | 1 | 19.62 hours |
| MADRONA/LESCHI | Theft From Motor Vehicle | 4 | 19.45 hours |
| HILLMAN CITY | Arson | 1 | 19.43 hours |
| NORTHGATE | Identity Theft | 1 | 18.98 hours |
| FIRST HILL | Shoplifting | 1 | 18.90 hours |
| BALLARD NORTH | Theft From Motor Vehicle | 5 | 18.79 hours |
| SLU/CASCADE | Destruction/Damage/Vandalism of Property | 7 | 18.54 hours |
| GREENWOOD | Robbery | 1 | 18.48 hours |
| GREENWOOD | Motor Vehicle Theft | 1 | 18.41 hours |
| NORTH BEACON HILL | Motor Vehicle Theft | 3 | 18.35 hours |
| UNIVERSITY | Extortion/Blackmail | 1 | 17.98 hours |
| UNIVERSITY | Motor Vehicle Theft | 4 | 17.93 hours |
| ROOSEVELT/RAVENNA | Motor Vehicle Theft | 6 | 17.92 hours |
| HIGH POINT | Motor Vehicle Theft | 1 | 17.87 hours |
| MAGNOLIA | Theft of Motor Vehicle Parts or Accessories | 2 | 17.69 hours |
| MORGAN | Motor Vehicle Theft | 1 | 17.65 hours |
| MILLER PARK | False Pretenses/Swindle/Confidence Game | 1 | 17.54 hours |
| MOUNT BAKER | Destruction/Damage/Vandalism of Property | 2 | 17.00 hours |
| JUDKINS PARK/NORTH BEACON HILL | Motor Vehicle Theft | 1 | 16.99 hours |
| BELLTOWN | Theft From Motor Vehicle | 11 | 16.87 hours |
| ALASKA JUNCTION | Theft From Building | 2 | 16.86 hours |
| SANDPOINT | Murder & Nonnegligent Manslaughter | 1 | 16.39 hours |
| CENTRAL AREA/SQUIRE PARK | Motor Vehicle Theft | 1 | 16.19 hours |
| NORTH DELRIDGE | Identity Theft | 2 | 16.10 hours |
| NORTH BEACON HILL | Theft From Motor Vehicle | 4 | 15.97 hours |
| SOUTH PARK | Motor Vehicle Theft | 1 | 15.49 hours |
| NORTHGATE | Theft From Building | 6 | 14.92 hours |
| ALKI | Motor Vehicle Theft | 1 | 14.50 hours |
| WALLINGFORD | Theft From Building | 1 | 14.41 hours |
| WALLINGFORD | Motor Vehicle Theft | 2 | 14.39 hours |
| GEORGETOWN | Theft From Motor Vehicle | 2 | 14.12 hours |
| MORGAN | Theft From Motor Vehicle | 1 | 14.05 hours |
| SANDPOINT | Motor Vehicle Theft | 2 | 14.05 hours |
| GREENWOOD | Theft of Motor Vehicle Parts or Accessories | 1 | 13.83 hours |
| BALLARD SOUTH | False Pretenses/Swindle/Confidence Game | 1 | 13.49 hours |
| NORTHGATE | Motor Vehicle Theft | 1 | 13.06 hours |
| HIGHLAND PARK | Theft From Motor Vehicle | 2 | 12.53 hours |
| CAPITOL HILL | Motor Vehicle Theft | 5 | 12.22 hours |
| CLAREMONT/RAINIER VISTA | Destruction/Damage/Vandalism of Property | 1 | 12.05 hours |
| PIONEER SQUARE | Driving Under the Influence | 2 | 11.95 hours |
| SANDPOINT | False Pretenses/Swindle/Confidence Game | 2 | 11.84 hours |
| UNIVERSITY | Destruction/Damage/Vandalism of Property | 8 | 11.57 hours |
| SOUTH BEACON HILL | Driving Under the Influence | 2 | 11.40 hours |
| SLU/CASCADE | Motor Vehicle Theft | 5 | 11.23 hours |
| SLU/CASCADE | Robbery | 3 | 11.05 hours |
| PHINNEY RIDGE | Motor Vehicle Theft | 1 | 10.88 hours |
| DOWNTOWN COMMERCIAL | Motor Vehicle Theft | 1 | 10.74 hours |
| PHINNEY RIDGE | Wire Fraud | 1 | 10.54 hours |
| FREMONT | Motor Vehicle Theft | 5 | 10.50 hours |
| MADISON PARK | Theft From Motor Vehicle | 1 | 10.30 hours |
| RAINIER BEACH | Theft From Motor Vehicle | 1 | 10.29 hours |
| FIRST HILL | Destruction/Damage/Vandalism of Property | 4 | 10.24 hours |
| FIRST HILL | Theft From Building | 1 | 10.20 hours |
| BRIGHTON/DUNLAP | Destruction/Damage/Vandalism of Property | 2 | 10.05 hours |
| CAPITOL HILL | Destruction/Damage/Vandalism of Property | 6 | 9.15 hours |
| DOWNTOWN COMMERCIAL | Destruction/Damage/Vandalism of Property | 9 | 8.88 hours |
| SOUTH BEACON HILL | Destruction/Damage/Vandalism of Property | 1 | 8.82 hours |
| LAKEWOOD/SEWARD PARK | Motor Vehicle Theft | 1 | 8.79 hours |
| GREENWOOD | Stolen Property Offenses | 2 | 8.75 hours |
| DOWNTOWN COMMERCIAL | Driving Under the Influence | 1 | 8.36 hours |
| HIGHLAND PARK | Motor Vehicle Theft | 3 | 8.00 hours |
| LAKEWOOD/SEWARD PARK | Theft From Motor Vehicle | 4 | 7.93 hours |
| JUDKINS PARK/NORTH BEACON HILL | Destruction/Damage/Vandalism of Property | 1 | 7.77 hours |
| CAPITOL HILL | Robbery | 5 | 7.65 hours |
| ALASKA JUNCTION | Theft of Motor Vehicle Parts or Accessories | 1 | 7.56 hours |
| HIGHLAND PARK | All Other Larceny | 2 | 7.36 hours |
| FIRST HILL | All Other Larceny | 3 | 7.31 hours |
| CAPITOL HILL | Shoplifting | 7 | 6.70 hours |
| QUEEN ANNE | Driving Under the Influence | 2 | 6.47 hours |
| CENTRAL AREA/SQUIRE PARK | Kidnapping/Abduction | 1 | 6.23 hours |
| PHINNEY RIDGE | Driving Under the Influence | 1 | 6.14 hours |
| NORTH BEACON HILL | Fondling | 1 | 6.06 hours |
| BITTERLAKE | Driving Under the Influence | 1 | 5.94 hours |
| UNIVERSITY | False Pretenses/Swindle/Confidence Game | 1 | 5.91 hours |
| BALLARD NORTH | Motor Vehicle Theft | 1 | 5.90 hours |
| DOWNTOWN COMMERCIAL | Drug/Narcotic Violations | 4 | 5.86 hours |
| QUEEN ANNE | Drug/Narcotic Violations | 2 | 5.79 hours |
| CHINATOWN/INTERNATIONAL DISTRICT | Theft From Building | 2 | 5.55 hours |
| SODO | Robbery | 1 | 5.25 hours |
| RAINIER BEACH | Fondling | 1 | 4.86 hours |
| BELLTOWN | Destruction/Damage/Vandalism of Property | 3 | 4.48 hours |
| PIGEON POINT | Theft From Motor Vehicle | 1 | 4.46 hours |
| FIRST HILL | Rape | 1 | 4.25 hours |
| CAPITOL HILL | Driving Under the Influence | 4 | 4.15 hours |
| MILLER PARK | Shoplifting | 1 | 4.00 hours |
| CAPITOL HILL | False Pretenses/Swindle/Confidence Game | 1 | 3.84 hours |
| SODO | Theft of Motor Vehicle Parts or Accessories | 2 | 3.74 hours |
| CHINATOWN/INTERNATIONAL DISTRICT | Weapon Law Violations | 1 | 3.73 hours |
| DOWNTOWN COMMERCIAL | Rape | 1 | 3.64 hours |
| DOWNTOWN COMMERCIAL | Sodomy | 1 | 3.64 hours |
| DOWNTOWN COMMERCIAL | Robbery | 7 | 3.60 hours |
| CHINATOWN/INTERNATIONAL DISTRICT | Shoplifting | 2 | 3.54 hours |
| CHINATOWN/INTERNATIONAL DISTRICT | Drug/Narcotic Violations | 2 | 3.53 hours |
| ALASKA JUNCTION | Driving Under the Influence | 3 | 3.51 hours |
| SLU/CASCADE | Sodomy | 1 | 3.51 hours |
| DOWNTOWN COMMERCIAL | Stolen Property Offenses | 1 | 3.45 hours |
| NORTHGATE | Drug/Narcotic Violations | 4 | 3.44 hours |
| WALLINGFORD | Shoplifting | 3 | 3.42 hours |
| BALLARD SOUTH | Robbery | 2 | 3.35 hours |
| QUEEN ANNE | Wire Fraud | 1 | 3.24 hours |
| SOUTH BEACON HILL | Robbery | 1 | 3.23 hours |
| PHINNEY RIDGE | Destruction/Damage/Vandalism of Property | 1 | 3.03 hours |
| QUEEN ANNE | Extortion/Blackmail | 1 | 3.02 hours |
| FAUNTLEROY SW | Motor Vehicle Theft | 1 | 2.91 hours |
| BITTERLAKE | Robbery | 1 | 2.88 hours |
| NEW HOLLY | Driving Under the Influence | 1 | 2.86 hours |
| NORTH BEACON HILL | Driving Under the Influence | 2 | 2.84 hours |
| FIRST HILL | Motor Vehicle Theft | 1 | 2.83 hours |
| BALLARD SOUTH | Theft of Motor Vehicle Parts or Accessories | 1 | 2.82 hours |
| NORTH BEACON HILL | Stolen Property Offenses | 1 | 2.82 hours |
| LAKEWOOD/SEWARD PARK | Destruction/Damage/Vandalism of Property | 1 | 2.81 hours |
| NORTHGATE | Driving Under the Influence | 2 | 2.72 hours |
| CHINATOWN/INTERNATIONAL DISTRICT | False Pretenses/Swindle/Confidence Game | 1 | 2.71 hours |
| ROXHILL/WESTWOOD/ARBOR HEIGHTS | Shoplifting | 2 | 2.70 hours |
| FIRST HILL | Driving Under the Influence | 1 | 2.60 hours |
| HIGH POINT | Driving Under the Influence | 1 | 2.56 hours |
| MADRONA/LESCHI | Shoplifting | 1 | 2.53 hours |
| DOWNTOWN COMMERCIAL | Shoplifting | 22 | 2.51 hours |
| NORTH ADMIRAL | Theft of Motor Vehicle Parts or Accessories | 2 | 2.51 hours |
| SLU/CASCADE | Shoplifting | 3 | 2.49 hours |
| HIGHLAND PARK | Weapon Law Violations | 1 | 2.43 hours |
| ROOSEVELT/RAVENNA | Stolen Property Offenses | 1 | 2.42 hours |
| GEORGETOWN | Stolen Property Offenses | 1 | 2.38 hours |
| SODO | Stolen Property Offenses | 1 | 2.38 hours |
| BALLARD NORTH | False Pretenses/Swindle/Confidence Game | 1 | 2.30 hours |
| ROOSEVELT/RAVENNA | Driving Under the Influence | 2 | 2.19 hours |
| EASTLAKE - EAST | Arson | 1 | 2.12 hours |
| NORTH ADMIRAL | Motor Vehicle Theft | 2 | 2.06 hours |
| UNIVERSITY | Shoplifting | 5 | 2.06 hours |
| ROXHILL/WESTWOOD/ARBOR HEIGHTS | Driving Under the Influence | 1 | 2.05 hours |
| BITTERLAKE | Sodomy | 1 | 2.04 hours |
| NORTH BEACON HILL | Destruction/Damage/Vandalism of Property | 2 | 2.02 hours |
| CAPITOL HILL | Drug Equipment Violations | 1 | 1.98 hours |
| GEORGETOWN | Drug/Narcotic Violations | 2 | 1.96 hours |
| NEW HOLLY | Shoplifting | 1 | 1.93 hours |
| HILLMAN CITY | Destruction/Damage/Vandalism of Property | 2 | 1.91 hours |
| SODO | Pocket-picking | 1 | 1.90 hours |
| BALLARD NORTH | Robbery | 1 | 1.89 hours |
| BITTERLAKE | Destruction/Damage/Vandalism of Property | 2 | 1.87 hours |
| UNIVERSITY | Robbery | 2 | 1.86 hours |
| MAGNOLIA | Destruction/Damage/Vandalism of Property | 3 | 1.85 hours |
| ALASKA JUNCTION | Destruction/Damage/Vandalism of Property | 2 | 1.81 hours |
| NORTH BEACON HILL | Shoplifting | 1 | 1.79 hours |
| MAGNOLIA | Robbery | 1 | 1.78 hours |
| FIRST HILL | Bad Checks | 1 | 1.74 hours |
| GREENWOOD | Drug/Narcotic Violations | 1 | 1.73 hours |
| MADRONA/LESCHI | Stolen Property Offenses | 1 | 1.71 hours |
| MOUNT BAKER | Shoplifting | 2 | 1.65 hours |
| CAPITOL HILL | Drug/Narcotic Violations | 2 | 1.60 hours |
| DOWNTOWN COMMERCIAL | Counterfeiting/Forgery | 1 | 1.60 hours |
| MOUNT BAKER | Robbery | 1 | 1.60 hours |
| SOUTH DELRIDGE | Stolen Property Offenses | 1 | 1.60 hours |
| GREENWOOD | Weapon Law Violations | 1 | 1.58 hours |
| NORTHGATE | Shoplifting | 6 | 1.58 hours |
| MILLER PARK | All Other Larceny | 1 | 1.55 hours |
| MORGAN | Driving Under the Influence | 2 | 1.53 hours |
| NEW HOLLY | Theft From Motor Vehicle | 1 | 1.53 hours |
| CHINATOWN/INTERNATIONAL DISTRICT | Driving Under the Influence | 1 | 1.52 hours |
| ALASKA JUNCTION | Robbery | 1 | 1.51 hours |
| ALASKA JUNCTION | Identity Theft | 1 | 1.50 hours |
| HILLMAN CITY | Robbery | 1 | 1.50 hours |
| NORTHGATE | Stolen Property Offenses | 2 | 1.49 hours |
| MADRONA/LESCHI | Weapon Law Violations | 1 | 1.38 hours |
| MORGAN | Destruction/Damage/Vandalism of Property | 2 | 1.36 hours |
| NORTHGATE | Robbery | 1 | 1.30 hours |
| RAINIER BEACH | Shoplifting | 1 | 1.27 hours |
| SLU/CASCADE | Counterfeiting/Forgery | 1 | 1.26 hours |
| MAGNOLIA | Drug/Narcotic Violations | 1 | 1.24 hours |
| BELLTOWN | Drug/Narcotic Violations | 2 | 1.21 hours |
| HIGH POINT | Theft From Building | 1 | 1.19 hours |
| NEW HOLLY | Robbery | 2 | 1.17 hours |
| NORTHGATE | Kidnapping/Abduction | 1 | 1.16 hours |
| COLUMBIA CITY | Destruction/Damage/Vandalism of Property | 1 | 1.13 hours |
| GEORGETOWN | False Pretenses/Swindle/Confidence Game | 1 | 0.88 hours |
| CHINATOWN/INTERNATIONAL DISTRICT | Robbery | 1 | 0.86 hours |
| CHINATOWN/INTERNATIONAL DISTRICT | Liquor Law Violations | 1 | 0.85 hours |
| FIRST HILL | False Pretenses/Swindle/Confidence Game | 1 | 0.85 hours |
| CENTRAL AREA/SQUIRE PARK | Shoplifting | 1 | 0.79 hours |
| BALLARD SOUTH | Shoplifting | 3 | 0.78 hours |
| GEORGETOWN | Counterfeiting/Forgery | 1 | 0.78 hours |
| SLU/CASCADE | Kidnapping/Abduction | 1 | 0.78 hours |
| FIRST HILL | Robbery | 1 | 0.74 hours |
| SOUTH PARK | All Other Larceny | 1 | 0.74 hours |
| GEORGETOWN | Weapon Law Violations | 1 | 0.60 hours |
| MID BEACON HILL | Destruction/Damage/Vandalism of Property | 2 | 0.59 hours |
| CAPITOL HILL | Counterfeiting/Forgery | 1 | 0.34 hours |
| CAPITOL HILL | Stolen Property Offenses | 1 | 0.01 hours |
| SLU/CASCADE | Stolen Property Offenses | 1 | 0.01 hours |
| BALLARD SOUTH | Driving Under the Influence | 1 | 0.00 hours |
| DOWNTOWN COMMERCIAL | Weapon Law Violations | 1 | 0.00 hours |
| MADRONA/LESCHI | Driving Under the Influence | 1 | 0.00 hours |
| SLU/CASCADE | Driving Under the Influence | 1 | -0.05 hours |
| MID BEACON HILL | Theft of Motor Vehicle Parts or Accessories | 1 | -1.26 hours |
| PIGEON POINT | Rape | 1 | NA |
| offense | occurances | report_delay |
|---|---|---|
| Rape | 4 | 10473.15 hours |
| Wire Fraud | 7 | 6507.21 hours |
| Identity Theft | 31 | 5251.58 hours |
| Embezzlement | 2 | 1459.23 hours |
| Human Trafficking, Commercial Sex Acts | 1 | 1441.09 hours |
| Fondling | 4 | 524.35 hours |
| Impersonation | 5 | 521.62 hours |
| Counterfeiting/Forgery | 12 | 290.17 hours |
| Credit Card/Automated Teller Machine Fraud | 20 | 283.59 hours |
| All Other Larceny | 114 | 264.13 hours |
| Theft of Motor Vehicle Parts or Accessories | 35 | 252.01 hours |
| Theft From Building | 50 | 165.89 hours |
| Extortion/Blackmail | 5 | 165.46 hours |
| Motor Vehicle Theft | 71 | 152.81 hours |
| False Pretenses/Swindle/Confidence Game | 16 | 121.71 hours |
| Destruction/Damage/Vandalism of Property | 128 | 111.29 hours |
| Theft From Motor Vehicle | 278 | 93.43 hours |
| Pornography/Obscene Material | 1 | 64.10 hours |
| Hacking/Computer Invasion | 3 | 55.36 hours |
| Bad Checks | 2 | 47.81 hours |
| Shoplifting | 81 | 44.81 hours |
| Sodomy | 5 | 33.48 hours |
| Kidnapping/Abduction | 4 | 32.48 hours |
| Pocket-picking | 2 | 31.16 hours |
| Arson | 3 | 20.60 hours |
| Murder & Nonnegligent Manslaughter | 1 | 16.39 hours |
| Driving Under the Influence | 38 | 14.67 hours |
| Robbery | 36 | 8.45 hours |
| Drug/Narcotic Violations | 20 | 3.42 hours |
| Stolen Property Offenses | 13 | 2.87 hours |
| Drug Equipment Violations | 1 | 1.98 hours |
| Weapon Law Violations | 6 | 1.62 hours |
| Liquor Law Violations | 1 | 0.85 hours |
One of the most important aspect of the “911 Seattle Call Data” is that it contains longitudinal and latitudinal numbers. With this information, we decided to create an interactive map to show the relative location of each criminal activity. This method offers a unique perspective on not only the location of each crime call, but also which ‘offense’ was committed, which area of Seattle had the highest density of calls/crimes, and which ‘criminal type’ offense was done.